Workplace Productivity Dashboard



Problem Statement

The Workplace Productivity Dashboard is a project I completed while volunteering as a Data Analyst through Catchafire.org. My client, Ms. Nicola, the Project Manager for the East Baltimore Research Project (a U.S. non-profit organization), requested a dashboard to summarize employee activities. The goal was to highlight how staff members allocate their time within the organization. For privacy reasons, the employee names shown in the published dashboard were aliased.


Methodology

Data Collection

No data collection was required for this project. Ms. Nicola provided an Excel spreadsheet containing workplace activity data from January to June. The spreadsheet included the following columns: Name, Date, Task, Remarks, and Hours Rendered.


Data Cleaning

Data cleaning was a critical step to ensure reliable analysis and visualization. This included addressing missing or uncategorized entries, correcting misspellings, and standardizing inconsistent punctuation and capitalization. These adjustments reduced the risk of errors during analysis.


Data Visualization

The dashboard was designed using a yellow and green theme to complement the organization’s logo.

  • Employee activity breakdown: Each employee’s activities were shown in a pie chart.
  • Overall task summary: A bar chart visualized the distribution of tasks, total hours per task, and overall hours rendered.
While the layout of the dashboard may be considered unconventional, it still achieved the goal of effective data storytelling and provided a clear overview of productivity trends.


Conclusion

  • N. Wilson (Project Manager) logged the highest number of contribution hours.
  • K. Davis and A. Smith had the lowest hours. There is, however, a lack of context of the nature of the positions of Davis and Smith wherein they could have been less essential to the project or have been employed on a project-based contract.
  • The remaining employees averaged around 150 hours, which could serve as a potential KPI benchmark for future planning by the project manager.
  • All employees spend at least 50% of their time in team meetings.